package luchbox;


public class Shop_sub extends SHOP{
	
	public String[][] select(){
		String SQL = "select shopID, shop_number, shop_name, shop_phone, " +
					"shop_address, stu_name from shop s1 inner join student s2 " +
					"on s1.data_creator = s2.studentID;";
		Object parameter[] = {};
		return super.select(SQL, parameter);
	}
	
	public String[][] select_order(){
		String SQL = "select shopID, shop_name from shop ";
		Object parameter[] = {};
		return super.select(SQL, parameter);
	}
	
	public String[][] select_name(String shop_name){
		String SQL = "select * from shop where shop_name=?";
		Object parameter[] = {shop_name};
		return super.select(SQL, parameter);
	}
}
